Winzipper

home *** CD-ROM | disk | FTP | other *** search

/ Winzipper / Winzipper_ISO.iso / programming / oracle7 7.2 / DB / UTIL72 / KOHUS.MSB < prev next >

Wrap

Text File | 1995-08-30 | 68.0 KB | 2,189 lines

S E S S I O N M E N U The Session menu commands allow you to connect to or disconnect from a database instance, enter a single operating system command, temporarily leave SQL*DBA in order to execute a series of operating system commands, or display debugging information for a stored procedure. C O N N E C T Connect to a database instance Supply a username and password to connect to a database instance and start a session. Command equivalent: CONNECT (SQL*DBA) Privilege Required: CREATE SESSION For more information, see: ORACLE7 Server Utilities User's Guide D I S C O N N E C T Disconnect from the instance. Command equivalent: DISCONNECT (SQL*DBA) Privilege Required: None For more information, see: ORACLE7 Server Utilities User's Guide E N T E R S Y S T E M Run a single operating system command from within SQL*DBA. Fill in the desired operating system command. The output is displayed in the output window. Command equivalent: HOST (SQL*DBA) Privilege Required: None For more information, see: ORACLE7 Server Utilities User's Guide G O T O S Y S T E M Temporarily leave SQL*DBA in order to execute a series of operating system commands. Choosing <Go To System> allows you to execute a series of operating system commands. The method for returning to SQL*DBA when finished is specific to each operating system. Consult your installation or user's guide for details. Command equivalent: HOST (SQL*DBA) Privilege Required: None For more information, see: ORACLE7 Server Utilities User's Guide S E R V E R O U T P U T O N Enables output to SQL*DBA output window from stored procedures and functions that use DBMS_OUTPUT PUTLINE calls. This option brings up a dialog box that lets you specify the message buffer size (the total number of bytes from messages that can be accumulated at any one time). The default buffer size is 2000 bytes. You must have the procedural option to create and execute stored procedures. Command equivalent: SET SERVEROUT (SQL*DBA) Privilege Required: None For more information, see: ORACLE7 Server Utilities User's Guide S E R V E R O U T P U T O F F Disables output to SQL*DBA output window from stored procedures and functions that use DBMS_OUTPUT PUTLINE calls. Command Equivalent: SET SERVEROUT (SQL*DBA) Privilege Required: None For more information, see: ORACLE7 Server Utilities User's Guide F I L E M E N U Use the File Menu options to run SQL scripts, turn spooling on and off, and exit SQL*DBA. S Q L S C R I P T Enter the filename of the script that you want to run. S P O O L O N Enables output spooling. Specify the name of the file that you want SQL*DBA's output to go to. S P O O L O F F Disables output spooling. Q U I T Exit SQL*DBA after committing the current transaction, terminating the session, and returning control to the operating system. Command equivalent: EXIT (SQL*DBA) Privilege Required: None For more information, see: ORACLE7 Server Utilities User's Guide E D I T M E N U Use the Edit Menu options to access the SQL*DBA editing operations. All of these commands work in the editing window. Some, such as Copy, Previous Command, and Next Command work from the output window as well. C U T Removes selected text and places it on the clipboard. C O P Y Copies the selected text to the clipboard. This command works in the output window as well as the editing window. P A S T E Pastes the contents of the clipboard at the current cursor location. C L E A R Erases the selected text. Does not affect the clipboard. N E X T C O M M A N D Copies the next command from the command history to the input window. This command works from the output window as well as from the editing window. P R E V I O U S C O M M A N D Copies the previous command from the command history to the input window. This command works from the output window as well as from the editing window. I N S T A N C E M E N U The Instance Menu commands allow you to use SQL*DBA to perform instance and database management. S T A R T U P Start up a database. Choose <Start Instance, Mount and Open Database> to mount and open a database. Choose <Start Instance and Mount Database> to mount a database without opening it. Choose <Start Instance Only> to start the instance without mounting or opening a database. Choose <Mount Exclusive> to open the database for exclusive use by this instance. Choose <Mount Parallel> to allow it to be shared by other instances. (If the database has already been opened by another instance, then it must be opened in parallel mode.) For more information, consult the ORACLE7 Parallel Server Administrator's Guide. If you are running in parallel mode, you can choose <Retry> to attempt to reopen the database every five seconds, if the instance is busy being recovered by another instance. Choose <Database Name> to specify the name of the database in the data entry field. If an initialization parameter file is specified, then the name of the database is given by the DB_NAME initialization parameter. If the database name is also specified in the <Database Name> field, then the specifications must match. (The DB_NAME parameter is described in the ORACLE7 Server Administrator's Guide.) Choose <Parameter File> to specify the name of the initialization parameter file. Choose <Abort Current Instance Before Startup> to abort the current instance and start the new instance in one operation. This option should only be used when an existing database cannot be shut down, or when an instance will not start due to internal problems. Choose <Enable Restricted Access> to allow general database access. By default, database access is restricted to users who have the RESTRICTED SESSION system privilege. Choose <Recover Before Open> to mount the database without opening it, and do full database recovery. Command equivalent: STARTUP (SQL*DBA) Privilege Required: Connected as Internal For more information, see: ORACLE7 Server Administrator's Guide S H U T D O W N Shut down a database. When you choose <Shut Down>, a sidebar menu is displayed, allowing termination in one of 3 ways: <Normal>, <Immediate>, or <Abort Instance>. <Normal>: Shuts down after all current users have disconnected from the database. New users are prevented from connecting, but current users can complete their work. <Immediate>: Immediately disconnects all users, rollbacks any uncommitted transactions, and shuts down as soon as the rollbacks complete. <Abort Instance>: Immediately shuts down the database without waiting for transactions to roll back. This option is only for use in emergency situations. This option forces instance recovery on startup. In Trusted ORACLE, you can use the SHUTDOWN command at the command line prompt to automatically shut down a secondary database. At the command line prompt, specify one of the shutdown parameters (ABORT, IMMEDIATE, or NORMAL) followed by the name of the database link to the secondary database to be shutdown. For example, to normally shut down a secondary database that has a database link of UNCLAS, you would issue the following command: SHUTDOWN NORMAL unclas Command equivalent: SHUTDOWN (SQL*DBA) Privilege Required: Connected as Internal For more information, see: ORACLE7 Server Administrator's Guide, and the Trusted ORACLE7 Server Administrator's Guide M O U N T D A T A B A S E When you choose <Mount Database>, a sidebar menu is displayed, giving you the choice of <Exclusive> or <Parallel>. Choose <Exclusive> to open the database for exclusive use by this instance, or <Parallel> to allow it to be shared by other instances. After performing this operation, you can carry out the administrative functions that require the database to be mounted, but not open. If the database has already been opened by another instance, then it must be opened in parallel mode. Choosing <Parallel> is only possible if you have installed the ORACLE Parallel Server. Consult the ORACLE7 Parallel Server Administrator's Guide for more information. Command equivalent: ALTER DATABASE MOUNT (SQL) Privilege Required: ALTER DATABASE If you are using Trusted ORACLE to mount a secondary database, additional prerequisites are needed. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE 7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide O P E N D A T A B A S E This option opens a mounted database, allowing users to connect to it. Command equivalent: ALTER DATABASE OPEN (SQL) Privilege Required: ALTER DATABASE If you are using Trusted ORACLE to open a secondary database, additional prerequisites are needed. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE 7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide F O R C E C H E C K P O I N T When you choose <Force Checkpoint>, an options menu is displayed, giving you the choice of <Local> or <Global>. In single-instance ORACLE, both options are equivalent. <Global>: Checkpoint all instances accessing the current database. This option is only useful for the ORACLE Parallel Server <Local>: Checkpoint only the instance to which you are currently connected. Command equivalent: ALTER SYSTEM CHECKPOINT (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide F O R C E L O G S W I T C H This option forces a log switch from the currently active redo log group to the next group. After the log switch completes, the members of the previously active group are available for maintenance operations, such as archiving. Command equivalent: ALTER SYSTEM SWITCH LOGFILE (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide C O N F I G U R E D I S P A T C H E R S Specify the number of dispatcher processes using specific protocols. Type in the protocol name and the total number of dispatchers that will use that protocol. Choose <Add> to insert that specification into the list of specifications to be implemented. Use the same procedure to specify the number of dispatchers using other protocols. To remove a protocol from the list, select it and then choose <Remove>. The existing number of dispatchers using that protocol then remains unchanged. To eliminate dispatchers using a specific protocol, specify that protocol, and then specify zero for the number of dispatchers. Command equivalent: ALTER SYSTEM SET MTS_DISPATCHERS (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide C O N F I G U R E S H A R E D S E R V E R Specify the number of shared server processes. Specify the total number of shared server processes that should exist, and choose [Ok]. Command equivalent: ALTER SYSTEM SET MTS_SERVERS (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide P R E V E N T C O N N E C T I O N This option restricts database access to those users with the RESTRICTED SESSION system privilege. Any users currently connected to the database continue without interruption, until they disconnect or are terminated with the KILL SESSION option in the INSTANCE menu. Command equivalent: ALTER SYSTEM ENABLE RESTRICTED SESSION (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide A L L O W C O N N E C T I O N This option opens database access to all users. Command equivalent: ALTER SYSTEM DISABLE RESTRICTED SESSION (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide K I L L S E S S I O N Kill a user session. When you choose <Kill Session> a list appears showing all current users, their sessions, and the serial number for each session. Select the session you want to terminate, using session number and serial number to distinguish between multiple sessions that belong to the same user. Then press [Execute] or choose <OK> to terminate the session. Command equivalent: ALTER SYSTEM KILL SESSION (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide S T O R A G E M E N U When you select the Storage menu command, a pull-right menu appears. You can choose to set Tablespace or Rollback Segment storage parameters. T A B L E S P A C E M E N U This menu provides access to the tablespace management commands available through SQL*DBA. For more information on the Tablespace menu commands, see the ORACLE7 Server Administrator's Guide C R E A T E Create a tablespace. This option lets you create a tablespace, specifying data files, default storage parameters, and whether the tablespace should go online immediately or stay offline. Begin by entering the name of the tablespace you want to create. Type filenames, separated by commas, at the <Data Files> prompt. (Filenames should be enclosed in single quotes if they contain any special characters.) Or use [List] to bring up the <File Specification> dialog box. <File Specification> Dialog Box: Type in the name of a new data file and specify its size in Kbytes or Mbytes. Choose <Reuse Existing File, If Present> to use an existing file after erasing its contents. If size is specified along with <Reuse Existing File, If Present>, the size must match the existing file. Choose <Add> to add the file specification to the list of files to be included in the tablespace. To remove a file from the list, select the file name and then choose <Remove>. Datafile specifications are discussed in the ORACLE7 Server Administrator's Guide. Select <Storage> and type in storage parameters separated by commas. (Storage parameters are described in the ORACLE7 Server Administrator's Guide.) Or use [List] to bring up the <Set Default Segment Storage> dialog box. <Set Default Segment Storage> Dialog Box: Check off the options you want to specify, and fill in their values. Extent size can be entered in Kbytes or Mbytes. Your specifications are then included in the create tablespace dialog. Choose if you want to bring the tablespace online immediately after it is created or leave it offline, by selecting either <Bring Online After Creation> or <Leave Offline After Creation> respectively. Command equivalent: CREATE TABLESPACE (SQL) Privilege Required: CREATE TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, your operating system label must be the equivalent of DBHIGH, your DBMS label must equal the label at which you want the tablespace created, and you cannot reuse a tablespace name that previously existed in the DBMS MAC database at a different label. Usage Notes If you are using Trusted ORACLE in either DBMS MAC or OS MAC mode, tablespaces are automatically labeled at your DBMS label. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide D R O P Drop a tablespace. Select the tablespace to drop. If the tablespace is empty, this selection is sufficient. If the tablespace is not empty, then you must also choose <Drop Constrained Objects, If Present> for the drop to succeed. You may also choose to cascade the drop of integrity constraints. If any integrity constraints from tables in other tablespaces reference tables in the tablespace to be dropped, then the drop fails if <Drop Dependent Referenctial Constraints> is not specified. If <Drop Dependent Referential Constraints> is specified, then all integrity constraints that reference the tables in the dropped tablespace are removed from the tables that contain them. Command equivalent: DROP TABLESPACE (SQL) Privilege Required: DROP TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the tablespace (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Administrator's Guide S E T O N L I N E Bring a tablespace online. All currently offline tablespaces are listed. Select a tablespace and choose <OK> to bring it online. Command equivalent: ALTER TABLESPACE ... ONLINE (SQL) Privilege Required: ALTER TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the tablespace (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide S E T O F F L I N E Take a tablespace offline. Select a tablespace and choose <OK> to take it offline. You may choose to take if off line in one of three ways: <After Checkpointing All Data Files of Tablespace>, <After Checkpointing Online Data Files of Tablespace>, or <Without Checkpointing Data Files of Tablespace>. <After Checkpointing All Data Files of Tablespace>: Checkpoint all data files in the tablespace and ensure that the files can be written before taking the tablespace offline. <After Checkpointing Online Data Files of Tablespace>: Checkpoint the online data files and ensure that they can be written. Then begin the checkpoint process. Continue without waiting for it to complete. Media recovery may be necessary when you bring the tablespace back online. <Without Checkpointing Data Files of Tablespace>: Take the tablespace offline without checkpointing. Media recovery is required when you bring the tablespace back online. This option is only allowed if the database is archiving. Command equivalent: ALTER TABLESPACE ... OFFLINE (SQL) Privilege Required: ALTER TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the tablespace (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide A D D D A T A F I L E Add data files to a tablespace. Select the tablespace to which you wish to add a data file, then type in filenames. Filenames should be enclosed in single quotes and separated by commas. Or use [List] to bring up the <File Specification> dialog box. <File Specification> Dialog Box: Type in a new filename and specify the file's size, or enter the name of an existing file. If the file already exists, specify <Reuse> to clear it of its current contents. (If, along with <Reuse>, the file's size is also specified, it must match the file's actual size.) Choose <Add> to insert that specification into the list of files to add. Use the same procedure to specify other files. To remove a file from the list, select it and then choose <Remove>. Command equivalent: ALTER TABLESPACE ADD DATAFILE (SQL) Privilege Required: ALTER TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the tablespace (your DBMS label must match the object's creation label or you must have sufficient MAC privileges) and your operating system label must be at the equivalent of DBHIGH. Usage Notes If you are using Trusted ORACLE, all files you add to the tablespace are classified at the operating system equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide R E N A M E D A T A F I L E Rename data files in a tablespace. Select the tablespace containing the files you want to rename, then type in the old filename or use [List] to bring up the <Current Datafiles List> dialog box. <Current Datafiles List> Dialog Box: Select one or more data files from this list, and choose <OK> to return to the <Rename Data File> dialog box--the old filename field is then filled in with your choices. Fill in the new filenames, then press [Execute] or choose <OK> to perform the rename. Command equivalent: ALTER TABLESPACE RENAME DATAFILE (SQL) Privilege Required: ALTER TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the tablespace (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide A L T E R D E F A U L T S T O R A G E Change default storage parameters for objects subsequently created in a tablespace. Choose the tablespace you want to change, check off the desired parameter(s), and fill in the appropriate value(s). Command equivalent: ALTER TABLESPACE ... DEFAULT STORAGE (SQL) Privilege Required: ALTER TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the tablespace (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide R O L L B A C K S E G M E N T M E N U The Rollback Segment menu provides access to the rollback segment management commands available through SQL*DBA. For more information on the Rollback Segment menu commands, see the ORACLE7 Server Administrator's Guide. C R E A T E Create a rollback segment. Choose <Public> or <Private> to specify the kind of rollback segment you want to create. Enter the name of the rollback segment, then enter the name of the tablespace in which to create it, or else select the tablespace field to bring up the <Tablespace List> dialog box. <Tablespace List> Dialog Box: Choose a tablespace from those listed, and select <Ok> to return to the <Create Rollback Segment> dialog box. To change storage parameters, position your cursor at the <Storage Parameters> prompt, and then specify the storage parameters (described in the ORACLE7 Server Administrator's Guide or use [List] to bring up the <Set Rollback Segment Storage> dialog box. <Set Rollback Segment Storage> Dialog Box: Check off the parameters you wish to set and fill in the appropriate values, then choose <Ok>. Extent and segment sizes can be entered in Kbytes or Mbytes. Command equivalent: CREATE ROLLBACK SEGMENT (SQL) Privilege Required: CREATE ROLLBACK SEGMENT Usage Notes If you are using Trusted ORACLE in either DBMS MAC or OS MAC mode, rollback segments are automatically labeled at your current DBMS label. For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide D R O P Drop a rollback segment. Select the rollback segment you want to drop, then press [Execute] or choose <OK> to drop it. Press [Cancel] or choose the <Cancel> button to exit from the list without dropping a rollback segment. Command equivalent: DROP ROLLBACK SEGMENT (SQL) Privilege Required: DROP ROLLBACK SEGMENT If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the rollback segment (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide, and the Trusted ORACLE7 Server Administrator's Guide S E T O N L I N E Bring a rollback segment online. Select the rollback segment you wish to bring online. Press [Execute] or choose <OK> to bring it online. Press [Cancel] or choose the <Cancel> button to exit without bringing it online. Command equivalent: ALTER ROLLBACK SEGMENT ... ONLINE (SQL) Privilege Required: ALTER ROLLBACK SEGMENT If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the rollback segment (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide S E T O F F L I N E Take a rollback segment offline. Select the rollback segment you want to take offline. Press [Execute] or choose <OK> to do so. Press [Cancel] or choose the <Cancel> button to exit without taking it offline. Command equivalent: ALTER ROLLBACK SEGMENT ... OFFLINE (SQL) Privilege Required: ALTER ROLLBACK SEGMENT If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the rollback segment (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide and the Trusted ORACLE7 Server Administrator's Guide A L T E R S T O R A G E Change storage parameters for a rollback segment. Select the rollback segment you wish to alter. Check off the parameters you want to change and fill in the appropriate values. Information on the structure of rollback segments, and guidelines for specifying storage parameters are given in the ORACLE7 Server Administrator's Guide. Command equivalent: ALTER ROLLBACK SEGMENT ... STORAGE (SQL) Privilege Required: ALTER ROLLBACK SEGMENT If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the rollback segment (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide L O G M E N U The Log menu provides access to the redo log management commands available through SQL*DBA. For more information on the Log menu commands, see the ORACLE7 Server Administrator's Guide. A D D G R O U P Add a new online redo log group. For parallel instances accessing the same database, you can specify the thread (instance) to which the new group will belong by filling in the appropriate thread number at the <Thread Number> prompt. Type the group number at the <Group Number> prompt. Enter the names of redo log files (that is, member names) in the <Online Redo Log Members> field. Filenames should be enclosed in single quotes and separated by commas. As an alternative to typing in the list, press [List] in the <Online Redo Log Members> field to bring up the <Specify Online Redo Log Members> dialog box. <Specify Online Redo Log Members> dialog box: Type in a filename. Choose <Add> to add it to the group. All files specified in this manner have the size specified in the <Member Size> field of the main dialog box. To drop a file from the group, select it and then choose <Remove>. Choosing <OK> or <Cancel> returns to the <Add Online Redo Log Group> dialog box. Enter the size, in Kbytes or Mbytes, in the <Member Size> field. This size applies to all files in the list. If you specify <Reuse Existing File>, then the file must exist and have the specified size. The file's contents are then erased. Command equivalent: ALTER DATABASE ADD LOGFILE GROUP (SQL) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide D R O P G R O U P Drop an online redo log group. Select the logfile group you want to drop and then press [Execute] or choose <OK> to drop it. Press [Cancel] or choose the <Cancel> button to exit the window without dropping a logfile group. Command equivalent: ALTER DATABASE DROP LOGFILE GROUP (SQL) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide A D D M E M B E R Add a redo log file to a redo log group. Specify a list of logfiles to add. Logfile names should be enclosed in quotes and separated by commas. As an alternative to typing the list, press the [List] key in the <Members to Add> field to bring up the <Specify Online Redo Log Members> dialog box. <Specify Online Redo Log Members> Dialog Box: Type in a filename. Choose <Add> to add it to the list. If you specify <Reuse>, the file must exist. (Its contents are then erased.) To remove a file from the list, select it and then choose <Remove>. Choose <OK> to return to the <Add Online Redo Log Member> dialog box. Enter the number of the group you wish to add members to, or use [List] to bring up the <Online Redo Log Group List>. <Online Redo Log Group List> Dialog Box: From this list box, you can select the redo log group to add to. Choose <OK> to return to the <Add Online Redo Log Member> dialog box. Command equivalent: ALTER DATABASE ADD LOGFILE MEMBER (SQL) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide R E N A M E M E M B E R Rename a redo log file in a redo log group. Type in the log file to rename, or use [List] to select the filename from the <Online Redo Log Member List> dialog box. Choose the log file to rename and select <OK> to approve your selection and return to the main dialog box. After specifying the filename, fill in the new filename in the original dialog box. Then press [Execute] or choose <Ok> to perform the rename. Command equivalent: ALTER DATABASE RENAME FILE (SQL) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide D R O P M E M B E R Drop a redo log file from a redo log group. Select the log file to drop and press [Execute] or choose <OK> to drop it. Press [Cancel] or choose the <Cancel> button to exit this window without dropping a logfile. Command equivalent: ALTER DATABASE DROP LOGFILE MEMBER (SQL) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide E N A B L E T H R E A D Enable the specified thread of redo log files. Choose the thread you want to enable. For parallel servers, you may also choose to make the thread available to any instance, instead of restricting it to the current instance. For single-instance ORACLE, these options are equivalent. Command equivalent: ALTER DATABASE ENABLE THREAD (SQL) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide D I S A B L E T H R E A D Disable a specified thread of redo log files. Choose the thread you want to disable. Press [Execute] or choose <OK> to disable it. Press [Cancel] or choose the <Cancel> button to exit this window without disabling a thread. Command equivalent: ALTER DATABASE DISABLE THREAD (SQL) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide S T A R T A U T O A R C H I V E Start automatic archiving of redo logs. Press [Execute] or choose <OK> to begin automatic archiving. To override the destination set at startup by the LOG_ARCHIVE_DEST parameter, enter a new destination at the <New Archive Destination> prompt. Command equivalent: ALTER SYSTEM ARCHIVE LOG START (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, and the Trusted ORACLE7 Server Administrator's Guide S T O P A U T O A R C H I V E Stop automatic archiving of redo logs. Command equivalent: ALTER SYSTEM ARCHIVE LOG STOP (SQL) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, and the Trusted ORACLE7 Server Administrator's Guide B E G I N M A N U A L A R C H I V E Perform a manual archive of one or more redo logs. Specifying the Thread --------------------- The default is to apply the options you choose to all threads (all instance's redo logfiles) in the database. To restrict archiving to a single thread, enter the thread number at the <Specific Thread Number> prompt, or use [List] to select from a list of threads. (For single-instance ORACLE there is only one thread, so this option is irrelevant.) <Thread Number List> Dialog Box: Choose a thread from the list and select <OK> to approve your choice and return to the main dialog box. Selecting Logfiles to Archive ----------------------------- You can choose to archive all unarchived groups, to archive only the oldest unarchived group, or to only archive selected groups. To archive a specific member of a group, enter the group number, or use [List] to select from a list of groups in the <Group Number List> dialog box. If you also specified a thread number, the specified redo log file group must be in the specified thread. <Group Number List> Dialog Box: Choose a group member from those listed and then select <OK> to approve your selection and return to the main dialog box. To archive an entire group that includes a certain member, specify the filename of the member at the <Specific Group Including Member> prompt. If you also specified a thread number, the specified redo log file group must be in the specified thread. When you specify a specific log sequence number, only the logfile you specify is archived. If you specify a system change number, then SQL*DBA archives all unarchived logs up to and including the one containing that SCN. If either the log sequence number or SCN causes the current logfile to be selected, then a log switch is forced, and the logfile is archived. Choosing <All Current Redo Information> is the same as specifying the current SCN, whatever it happens to be at the time. Setting Archive Destination --------------------------- The default archive destination is specified by the initialization parameter LOG_ARCHIVE_DEST, unless that destination has been changed with the ALTER SYSTEM ARCHIVE LOG command. To change the archive destination for the current archive operation, fill in the new destination at the <New Archive Destination> prompt. The change is effective for this archive only. Any subsequent automatic archives will continue to go to the default destination. Command equivalent: ALTER SYSTEM ARCHIVE LOG ... (SQL) (where "..." is anything but STOP or START) Privilege Required: ALTER SYSTEM If you are using Trusted ORACLE in DBMS MAC mode, your current DBMS label must be at the label equivalent of DBHIGH. For more information, see: ORACLE7 Server Administrator's Guide, and the Trusted ORACLE7 Server Administrator's Guide L I S T A R C H I V E S T A T U S This option produces a display containing redo logfile information, including archive destination, the sequence number of the next group to be archived, the sequence number of the group currently being used, and the sequence number of the oldest unarchived group. Command equivalent: ARCHIVE LOG LIST (SQL*DBA) Privilege Required: You must be connected as INTERNAL, OSDBA or OPER If you are using Trusted ORACLE in DBMS MAC mode, your DBMS label must be at the equivalent of DBHIGH. For more information, see: ORACLE7 Server Utilities User's Guide and the Trusted ORACLE7 Server Administrator's Guide B A C K U P M E N U The Backup menu provides access to the backup and recovery commands available through SQL*DBA. For more information on the Backup menu commands, see the ORACLE7 Server Administrator's Guide. B E G I N O N L I N E T A B L E S P A C E B A C K U P Mark a tablespace before backing it up with an operating system command or with the backup utility, so that ORACLE knows that a backup was in progress, and not complete, in the event that data recovery becomes necessary. Choose the tablespace you want to back up, and then press [Execute] or choose <OK> to get it ready for the backup. This is a necessary step in order to create a usable backup. Otherwise, the database cannot be reliably restored from the backup--even if recovery occurs without error, it may produce inconsistent data. Then use SQL*DBA's HOST command, or use the <Session> menu's <Enter System Command> option to back up the tablespace with an operating system command, or with the backup utility. (See your users or installation guide for details on operating system backups.) When the backup is complete, use the <End Online Tablespace Backup> option to return the tablespace to its normal state. Otherwise, when the database is shutdown, ORACLE will assume that tablespace recovery is necessary when the database is restarted. Command equivalent: ALTER TABLESPACE BEGIN BACKUP (SQL) Privilege Required: ALTER TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the tablespace (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide, and the Trusted ORACLE7 Server Administrator's Guide E N D O N L I N E T A B L E S P A C E B A C K U P Inform ORACLE that backup of a tablespace has completed. This step prevents unnecessary tablespace recovery the next time the database is started. After the backup is complete, select the tablespaces you backed up and mark them as ended. Command equivalent: ALTER TABLESPACE END BACKUP (SQL) Privilege Required: ALTER TABLESPACE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the tablespace (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Administrator's Guide, and the Trusted ORACLE7 Server Administrator's Guide R E C O V E R D A T A B A S E Perform media recovery on the entire database. Choose a full or incomplete recovery. The choice of incomplete recovery depends on your runtime configuration and type of media failure. A complete database recovery is necessary if a media failure occurred with the database running in NOARCHIVELOG mode. If you select an incomplete recovery, you must choose to continue recovery until: * you cancel recovery by issuing an ALTER DATABASE RECOVER CANCEL command, * the SCN specified in the <Until Change> field is reached, or * the time specified in the <Until Time> field is reached. Select the appropriate option, and enter a value as necessary. You must also indicate whether you want to use a backup version of the control file. You must use the backup control file if the original control file is lost or damaged and cannot be restored. Command equivalent: RECOVER DATABASE (SQL*DBA) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide R E C O V E R T A B L E S P A C E S Perform media recovery on tablespaces. Select the tablespace you need to recover. Press [Execute] or choose <OK> to perform the recovery. Press [Cancel] or choose the <Cancel> button to leave this menu without performing a recovery. Command equivalent: RECOVER TABLESPACE (SQL*DBA) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide R E C O V E R D A T A F I L E S Perform media recovery on data files. Select a data file for recovery. Press [Execute] or choose <OK> to perform the recovery. Press [Cancel] or choose the <Cancel> button to leave this menu without performing a recovery. Command equivalent: RECOVER DATAFILE (SQL*DBA) Privilege Required: ALTER DATABASE For more information, see: ORACLE7 Server Administrator's Guide S E C U R I T Y M E N U The Security menu provides access to the security commands available through SQL*DBA. For more information on the Security menu commands, see the ORACLE7 Server Administrator's Guide. C R E A T E U S E R Create a user definition. Fill in the name of the user you want to establish on the system. If database authentication is desired, choose the <Use Password Authentication> option and fill in the user's initial password value. If the host operating system is to be used for authentication, choose the <Use OS Authentication> option. To specify a default tablespace for the user's objects, fill in the <Default Tablespace> field or use [List] to select the tablespace from the <Default Tablespace List> dialog box. If no tablespace is specified, SYSTEM is used. <Default Tablespace List> Dialog Box: Select the tablespace from the list displayed and press <OK> to return to the main dialog box. To specify the user's temporary segment, either fill in the <Temporary Tablespace> field or use [List] to select the tablespace from the <Temporary Tablespace List> dialog box. The SYSTEM tablespace is used as the default. <Temporary Tablespace List> Dialog Box: Select the tablespace from the list displayed and press <OK> to return to the main dialog box. Next, specify the user's quota by typing the value at the <Quotas> prompt or using [List] to select from the <Tablespace Quotas> dialog box. This quota is the maximum space in the tablespace the user can allocate. <Tablespace Quotas> Dialog Box: You can choose to allow the user unlimited tablespace or to limit the tablespace to a specified number of Kbytes or Mbytes for a designated tablespace. Use the <Add> and <Remove> commands to add and remove tablespaces from the list of tablespace quotas that you want to specify. Press <OK> to approve your selections and return to the main dialog box. To establish the user's profile, fill in a profile name at the <Profile> prompt or use [List] to select from the <Profile List> dialog box. <Profile List> Dialog Box: Choose a profile from the list displayed and select <OK> to approve your choice and return to the main dialog box. When you are finished selecting your options, press [Execute] or choose <OK> to create the user. To set a user's default role, use the ALTER USER menu option. Command equivalent: CREATE USER (SQL) Privilege Required: CREATE USER If you are using Trusted ORACLE in DBMS MAC mode, to assign a default role to the user, your DBMS label must dominate the creation label of the role. To assign a default or temporary tablespace to the user, your DBMS label and the user's creation label must dominate the creation label of the tablespace. To assign a profile to the user, your DBMS label (and consequently, the user's creation label) must dominate the creation label of the profile. Usage Notes If you are using Trusted ORACLE in either DBMS MAC or OS MAC mode, users are automatically labeled at your current DBMS label. For more information, see: ORACLE7 Server Concepts Manual and the Trusted ORACLE7 Server Administrator's Guide A L T E R U S E R Alter a user definition. Select the name of the user definition you want to change. Choose <Change Password> to change an existing user's password, or fill in a new user's initial database password. Choose <Change to OS Authentication> to rely on the operating system's user authentication. To change the user's default tablespaces, enter a name in the <Default Object Tablespace> field or use [List] to select the tablespace from the <Tablespace List> dialog box. <Tablespace List> Dialog Box: Choose a tablespace from the list of those available, and select <OK> to approve your choice and return to the main dialog box. To change the user's temporary segment, enter a name in the <Temp Segment Tablespace> field, or use [List] to select the tablespace from the <Tablespace List> dialog box. To change the user's quota, enter a specification in the <Quota> field, or use [List] to fill in specifications using the <Tablespace Quotas> dialog box. <Tablespace Quotas> Dialog Box: You can choose to allow the user unlimited tablespace or to limit the tablespace to a specified number of Kbytes or Mbytes for a designated tablespace. Use the <Add> and <Remove> commands to add and remove tablespaces from the list of tablespace quotas that you want to specify. Press <OK> to approve your selections and return to the main dialog box. To change the user's profile, fill in a profile name or use [List] to select from the <Profile List> dialog box. <Profile List> Dialog Box: Choose a profile from the list displayed and select <OK> to approve your choice and return to the main dialog box. To set or change the user's list of default roles enter a list of roles separated by commas at the <Default Roles> prompt, or use [List] to bring up the <Role List> dialog box. <Role List> Dialog Box: Make your choice of role assignments by selecting the roles to assign. Press [Execute] or choose <OK> to indicate that you have finished making choices and return to the <Alter User> dialog. When you are finished making changes at the <Alter User> dialog, press [Execute] or choose <OK> to make them effective. Press [Cancel] or choose the <Cancel> button to leave the user definition unchanged. Command equivalent: ALTER USER (SQL) Privilege Required: ALTER USER If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the user (your DBMS label must match the user's creation label or you must have sufficient MAC privileges). To assign a default role to a user, you must have read access to the role (your DBMS label must dominate the role's creation label or you must have sufficient MAC privileges), your DBMS label must match the user's creation label, and the user's creation label must dominate that of the role. To assign a default or temporary tablespace to a user, both you and the user must have read access to the tablespace. To assign a profile to a user, you must have write access to the user and both you and the user must have read access to the profile. For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide D R O P U S E R Drop a user definition. Select the user definition you want to drop. If you want to drop all of the objects in the user's schemas well, choose <Including Associated Schema Objects>. If this option is not chosen, and the associated schema is not empty, the user definition is not dropped. Command equivalent: DROP USER (SQL) Privilege Required: DROP USER If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the user (your DBMS label must match the user's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide C R E A T E R O L E Define an abstract category of users so that you can grant or revoke privileges on all users in that category with one operation. Fill in the name of the role you want to create. Choose the user authentication method. Then press [Execute] or choose <OK> to create the role. Press [Cancel] or choose the <Cancel> button to leave this menu without creating a role. To set the role's privileges, use the <Grant> and <Revoke> options from the <Security> menu. Command equivalent: CREATE ROLE (SQL) Privilege Required: CREATE ROLE Usage Notes If you are using Trusted ORACLE in either DBMS MAC or OS MAC mode, roles are automatically labeled at your current DBMS label. For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide A L T E R R O L E Change the authentication method for a role. Select the role you want to change, then choose the new authentication method. This is the only change you can make to a role from this menu. To change the privileges associated with a role, use the <Grant> and <Revoke> options from the <Security> menu. Command equivalent: ALTER ROLE (SQL) Privilege Required: ALTER ANY ROLE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the role (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide D R O P R O L E Drop a role. Select the role you want to drop. Press [Execute] or choose <OK> to perform the drop. Press [Cancel] or choose the <Cancel> button to leave this menu without dropping a role. Command equivalent: DROP ROLE (SQL) Privilege Required: DROP ANY ROLE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the role (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide C R E A T E P R O F I L E Create a profile that can be assigned to users in order to limit their use of system resources. Select the resources you want to limit, and fill in the appropriate values. Command equivalent: CREATE PROFILE Privilege Required: CREATE PROFILE Usage Notes If you are using Trusted ORACLE in either DBMS MAC or OS MAC mode, profiles are automatically labeled at your current DBMS label. For more information, see: ORACLE7 Server Concepts Manual, the ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide A L T E R P R O F I L E Modify a profile used to limit use of system resources. Select the profile that you want to modify. Then select the resource limits you want to change, and fill in the appropriate values. Command equivalent: ALTER PROFILE Privilege Required: ALTER PROFILE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the profile (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide D R O P P R O F I L E Drop a resource-limit profile. Select the profile you want to drop. If the profile is currently assigned to any users, you must specify <Reassign Profile> in order to drop it. Those users are then assigned the DEFAULT profile. Command equivalent: DROP PROFILE Privilege Required: DROP PROFILE If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to the profile (your DBMS label must match the object's creation label or you must have sufficient MAC privileges). For more information, see: ORACLE7 Server Concepts Manual, and the Trusted ORACLE7 Server Administrator's Guide A L T E R R E S O U R C E C O S T Specify a formula for calculating the total cost of resources used in a session. Specify a numeric weight (zero or greater) for each of the resource cost factors: * CPU time, in hundredths of seconds * Connect time, in minutes * logical reads, in number of database blocks * private SGA space, in bytes The measurements for each session are multiplied by corresponding weights and added together to produce a composite measure of resource utilization, which is compared against the COMPOSITE_LIMIT specified in a resource-limit profile. Command equivalent: ALTER RESOURCE COST (SQL) Privilege Required: ALTER RESOURCE COST If you are using Trusted ORACLE in DBMS MAC mode, you must have write access to DBLOW (your DBMS label must match DBLOW or you must have sufficient writedown MAC privileges). For more information, see: The ORACLE7 Server SQL Language Reference Manual, and the Trusted ORACLE7 Server Administrator's Guide G R A N T Grant system privileges and roles to a user or to a role. System Privileges and Roles to Grant ------------------------------------ Enter a list of system privileges separated by commas, or use [List] to bring up the <System Privileges and Role List> dialog box. <System Privileges and Role List> Dialog Box: Choose the system privileges and roles you want to grant. Press [Execute] or choose <OK> to accept this list and return to the <Grant> menu. Users and Roles to Receive Grants --------------------------------- Enter a list of users and roles to receive the grants, separated by commas, or use [List] to bring up the <User and Role List> dialog box. <User and Role List> Dialog Box: Choose the users and roles you want to grant to. Press [Execute] or choose <OK> to accept this list and return to the <Grant> menu. Select the <Allow grantee to grant privilege(s)/role(s) to others> option to allow the person receiving the privilege or role to grant the privilege or role to another user. Command equivalent: GRANT (SQL) Privilege Required: GRANT ANY ROLE, and/or other privileges that include the ADMIN option If you are using Trusted ORACLE in DBMS MAC mode, to grant a privilege, your DBMS label must dominate the label at which the privilege was granted to you. In addition, your DBMS label must dominate the creation label of the user or role to whom you are granting the privilege. To grant roles to users, your DBMS label must dominate the grant and the creation label of the role. Usage Notes If you are using Trusted ORACLE in DBMS MAC mode, you can only grant privileges and roles at your current DBMS label. For more information, see: ORACLE7 Server Concepts Manual and the Trusted ORACLE7 Server Administrator's Guide R E V O K E Revoke system privileges and roles from users and from roles. System Privileges and Roles to Revoke ------------------------------------- Enter a list of system privileges separated by commas, or use [List] to bring up the <System Privilege and Role List> dialog box. <System Privilege and Role List> Dialog Box: Choose the system privileges and roles you want to revoke. Press [Execute] or choose <OK> to accept this list and return to the <Grant> menu. Users and Roles to Revoke From ------------------------------ Enter a list of users and roles to revoke from, separated by commas, or use [List] to bring up the <User and Role List> dialog box. <User and Role List> Dialog Box: Choose the users and roles you want to revoke from. Press [Execute] or choose <OK> to accept this list and return to the <Grant> menu. Command equivalent: REVOKE (SQL) Privilege Required: GRANT ANY ROLE and/or other privileges that include the ADMIN option If you are using Trusted ORACLE in DBMS MAC mode, to revoke system privileges and roles from users and roles, you must have write access to the grant of the privilege or role (your DBMS label must match the label at which the privilege or role was granted or you must have sufficient MAC privileges). To revoke object privileges for a particular object from users and roles, you must have write access to the grant of the privilege (your DBMS label must match the label at which the privilege was granted or you must have sufficient MAC privileges). M O N I T O R S M E N U The Monitors menu allows you to dynamically monitor ORACLE to track the availability and use of resources. For a complete description of the monitors, see the ORACLE7 Server Utilities User's Guide. M U L T I T H R E A D E D M O N I T O R The multi threaded monitors show information on ORACLE's management of multiple sessions on shared servers. S H A R E D S E R V E R M O N I T O R The shared server monitor displays server processes. Enter a server name template, or pattern, to determine which servers are displayed. Select a status-pattern or leave the default entry for all status values. Press [Execute] or select the <Start> button to begin monitoring. Once monitoring begins, this buttons name becomes <Restart>. You can change the display criteria at any time and press [Execute] or select <Restart> to initiate a new display. D I S P A T C H E R M O N I T O R This monitor displays information on the shared server's dispatcher processes. Enter a template for the names of dispatcher process IDs you want to monitor. Select a status pattern or leave the default entry for all status values. Press [Execute] or select the <Start> button to begin monitoring. Once monitoring begins, this buttons name becomes <Restart>. You can change the display criteria at any time and press [Execute] or select <Restart> to initiate a new display. C I R C U I T M O N I T O R Monitoring begins immediately with this display. Press [Execute] or select <Restart> to initiate a new display. The first five columns specify a unique system path identified by circuit, server, dispatcher, session ID, and session serial number. For each path, the monitor shows circuit status, currently active queue, number of messages, and total bytes transfered. Q U E U E M O N I T O R Monitoring begins immediately with this display. Press [Execute] or select <Restart> to initiate a new display. The first two columns identify a particular queue and the process that owns it. The next three columns identify the number of messages currently in the queue, the total number of messages that have ever been in the queue, and the average wait time for each message. P R O C E S S M O N I T O R The process monitor shows all background and user processes currently accessing the database through the current instance. Enter the range of ORACLE process IDs that you want to monitor. Press [Execute] or select the <Start> button to begin monitoring. Once monitoring begins, this buttons name becomes <Restart>. You can change the display criteria at any time and press [Execute] or select <Restart> to initiate a new display. S E S S I O N M O N I T O R The session monitor shows statistics and information for each user session in the current instance. Monitoring begins immediately with this display. Press [Execute] or select <Restart> to initiate a new display. This display shows the session ID and session serial number currently assigned to the username, the ORACLE Process ID (PID), the session's status, ORACLE username, and the most recent SQL statement executed in that session. T A B L E A C C E S S M O N I T O R You can control the display with any of the following: * Minimum Session ID number * Maximum Session ID number * Schema Filter * Table Filter Press [Execute] or select the <Start> button to begin monitoring. Once monitoring begins, this buttons name becomes <Restart>. You can change the display criteria at any time and press [Execute] or select <Restart> to initiate a new display. S Q L A R E A M O N I T O R The SQL area monitor shows the memory used to process SQL statements that have been, or are being, executed. You can specify a pattern in the <Statement Filter> to restrict the display. Press [Execute] or select the <Start> button to begin monitoring. Once monitoring begins, this buttons name becomes <Restart>. You can change the display criteria at any time and press [Execute] or select <Restart> to initiate a new display. L I B R A R Y C A C H E M O N I T O R The library cache monitor shows the activity in, and effectiveness of, the library cache. Fill in the name of the cache you want to monitor, or leave the default value intact to monitor all cache areas. Press [Execute] or select the <Start> button to begin monitoring. Once monitoring begins, this buttons name becomes <Restart>. You can change the display criteria at any time and press [Execute] or select <Restart> to initiate a new display. L A T C H M O N I T O R The latch monitor shows how internal data structure latches are being used. Latches protect shared data structures in the SGA. Monitoring begins immediately with this display. Press [Execute] or select <Restart> to initiate a new display. L O C K M O N I T O R The lock monitor monitors database locks. Monitoring begins immediately with this display. Press [Execute] or select <Restart> to initiate a new display. The combination of Session ID and Serial Number uniquely identifies a user session. The values in the Mode Held and Mode Requested columns have the following meanings: 1 - Null 2 - ROW SHARE, SHARE UPDATE 3 - ROW EXCLUSIVE 4 - SHARE 5 - SHARE ROW EXCLUSIVE 6 - EXCLUSIVE F I L E I / O M O N I T O R The file I/O monitor shows the read and write activity on each file in the database. Enter a filename template, or pattern, to determine which files are displayed. Press [Execute] or select the <Start> button to begin monitoring. Once monitoring begins, this buttons name becomes <Restart>. You can change the display criteria at any time and press [Execute] or select <Restart> to initiate a new display. S Y S T E M I / O D I S T R I B U T I O N M O N I T O R The system I/O distribution monitor shows the percentage of I/O activity generated by each background and user process that is accessing the database through the current instance. This information indicates relative distributions, not precise counts of I/O operations. Monitoring begins immediately with this display. Press [Execute] or select <Restart> to initiate a new display. R O L L B A C K S E G M E N T M O N I T O R The rollback segment monitor shows the current status of rollback segments. Enter a filename template, or pattern, to determine which files are displayed. Press [Execute] or select the <Start> button to begin monitoring. Once monitoring begins, this buttons name becomes <Restart>. You can change the display criteria at any time and press [Execute] or select <Restart> to initiate a new display. S T A T I S T I C M O N I T O R The statistic monitors show runtime statistics on system use and performance for the current instance. You can choose to show statistics for the selected sessions, or system-wide. S E S S I O N S T A T I S T I C M O N I T O R The session statistic monitor shows runtime statistics on system use and performance for selected sessions. Fill in the range of sessions you want to monitor. The default is all sessions. Then select the types of statistics you want to display. Use [Execute] or choose <Restart> to initiate a new display. S Y S T E M S T A T I S T I C M O N I T O R The system statistic monitor shows runtime statistics on system use and performance system-wide. Select the types of statistics you want to display. Use [Execute] or choose <Restart> to initiate a new display. H E L P M E N U The Help menu allows you to view a list of help topics, to view a list of the function keys that can be used with SQL*DBA, or to receive information about the version of SQL*DBA that you are using. S H O W K E Y S The Show Keys command allows you to view a list of the function keys and control key sequences that can be used with SQL*DBA. A brief explanation of their function is also provided. A B O U T S Q L * D B A The About SQL*DBA command allows you to view information about the version of SQL*DBA that you are running. Select from the list of topics to receive brief information about that topic. More detailed information on the use of SQL*DBA is provided in the ORACLE7 Server Utilities User's Guide. You can also receive help from within a dialog box, by selecting the <Help> key. The help information relevant to that dialog box is displayed.